//package com.quartz.dao;
//
//import com.quartz.entity.JobAndTrigger;
//import org.apache.ibatis.annotations.*;
//
//import java.util.List;
//
///**
// * @program: myspringboot
// * @description:
// * @author: zyj
// * @create: 2020-01-02 11:52
// **/
//@Mapper
//public interface QuartzDao {
//
//    @Results({
//            @Result(column="JOB_NAME", property="jobName"),
//            @Result(column="JOB_GROUP", property="jobGroup"),
//            @Result(column="JOB_CLASS_NAME", property="jobClassName"),
//            @Result(column="DESCRIPTION", property="description"),
//            @Result(column="TRIGGER_NAME", property="triggerName"),
//            @Result(column="TRIGGER_GROUP", property="triggerGroup"),
//            @Result(column="REPEAT_INTERVAL", property="repeatInterval"),
//            @Result(column="TIMES_TRIGGERED", property="timesTriggered"),
//            @Result(column="CRON_EXPRESSION", property="cronExpression"),
//            @Result(column="TIME_ZONE_ID", property="timeZoneId"),
//            @Result(column="TRIGGER_STATE", property="triggerState")
//    })
//    @Select("SELECT " +
//            " qrtz_job_details.JOB_NAME, " +
//            " qrtz_job_details.JOB_GROUP, " +
//            " qrtz_job_details.JOB_CLASS_NAME, " +
//            " qrtz_job_details.DESCRIPTION, " +
//            " qrtz_triggers.TRIGGER_NAME, " +
//            " qrtz_triggers.TRIGGER_GROUP, " +
//            " qrtz_cron_triggers.CRON_EXPRESSION, " +
//            " qrtz_cron_triggers.TIME_ZONE_ID, " +
//            " qrtz_triggers.TRIGGER_STATE " +
//            " FROM " +
//            " qrtz_job_details " +
//            " JOIN qrtz_triggers " +
//            " JOIN qrtz_cron_triggers ON qrtz_job_details.JOB_NAME = qrtz_triggers.JOB_NAME " +
//            " AND qrtz_triggers.TRIGGER_NAME = qrtz_cron_triggers.TRIGGER_NAME " +
//            " AND qrtz_triggers.TRIGGER_GROUP = qrtz_cron_triggers.TRIGGER_GROUP "
//    )
//    List<JobAndTrigger> jobAndTriggerList();
//}
